DROP TABLE PHP_USERS;

CREATE TABLE PHP_USERS(
  ID NUMBER(5) PRIMARY KEY,
  USERNAME VARCHAR2(15) UNIQUE,
  PASS VARCHAR(50));
  
  
  CREATE OR REPLACE TRIGGER "A8VALOIPH"."PHP_TRIGUSERS" before insert on "PHP_USERS"    for each row begin     if inserting then       if :NEW."ID" is null then          select PHPSEQ.nextval into :NEW."ID" from dual;       end if;    end if; end;
/
ALTER TRIGGER "A8VALOIPH"."PHP_TRIGUSERS" ENABLE;
 

  
INSERT INTO PHP_USERS
  (USERNAME, PASS)
  VALUES('Admin','e3afed0047b08059d0fada10f400c1e5');
  
INSERT INTO PHP_USERS
  (USERNAME, PASS)
  VALUES('Ben','092f2ba9f39fbc2876e64d12cd662f72');
  
INSERT INTO PHP_USERS
  (USERNAME, PASS)
  VALUES('Phil','9ec75097ce44559e94e404d6a2d395ab');
  
commit;